SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TDU_Importacao](
	[CDU_TipoDoc] [varchar](50) NULL,
	[CDU_Id_Expedicao] [int] NULL,
	[CDU_NumDoc] [int] NULL,
	[CDU_NCliente] [varchar](128) NULL,
	[CDU_NomeCliente] [varchar](128) NULL,
	[CDU_MoradaCliente] [varchar](128) NULL,
	[CDU_CodigoPostalCliente] [varchar](128) NULL,
	[CDU_Requisicao] [varchar](256) NULL,
	[CDU_Moeda] [varchar](10) NULL,
	[CDU_Cambio] [varchar](10) NULL,
	[CDU_Data] [datetime] NULL,
	[CDU_Vencimento] [datetime] NULL,
	[CDU_NContribuinteCliente] [varchar](50) NULL,
	[CDU_DescCi] [varchar](10) NULL,
	[CDU_CondicaoPagamento] [varchar](10) NULL,
	[CDU_DescFin] [varchar](10) NULL,
	[CDU_Zona] [varchar](10) NULL,
	[CDU_Vend] [varchar](10) NULL,
	[CDU_Pag] [varchar](10) NULL,
	[CDU_Artigo] [varchar](128) NULL,
	[CDU_Descricao] [varchar](256) NULL,
	[CDU_Quantidade] [float] NULL,
	[CDU_Unidade] [varchar](50) NULL,
	[CDU_LocalCarga] [varchar](256) NULL,
	[CDU_LocalDescarga] [varchar](256) NULL,
	[CDU_Matricula] [varchar](128) NULL,
	[CDU_Carga] [datetime] NULL,
	[CDU_Descarga] [datetime] NULL,
	[CDU_ModoExpedicao] [varchar](10) NULL,
	[CDU_Armazem] [varchar](50) NULL,
	[CDU_Lote] [varchar](50) NULL,
	[CDU_DescricaoLote] [varchar](50) NULL,
	[CDU_DataFabrico] [datetime] NULL,
	[CDU_Validade] [datetime] NULL,
	[CDU_Controlador] [varchar](50) NULL,
	[CDU_Observacoes] [varchar](512) NULL,
	[CDU_DataImportacao] [datetime] NULL,
	[CDU_Id] [int] IDENTITY(1,1) NOT NULL,
	[CDU_NumeroDocumento] [int] NULL,
	[CDU_TipoDocumento] [varchar](128) NULL,
	[CDU_PCusto] [float] NULL,
	[CDU_PrecUnit] [float] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


